package com.simulation.superlotto.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.simulation.superlotto.model.Bonus;
import com.simulation.superlotto.model.Contrast;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author ：XXX
 * @date ：Created in 2020/12/4
 * @description ：
 * @version: 1.0
 */
public interface ContrastDao extends BaseMapper<Contrast> {
    @Select("select * from bonus where red_ball=#{a} and blue_ball=#{b}")
    Bonus selectMoney(@Param("a") int a, @Param("b")int b);
    @Select("select profit_money from bonus where bonus_name=#{name} limit 1")
    long selectbonusName(@Param("name") String name);
}
